@Vamsikrishna Immadisetty :

You are correct that the Dynamics AX connector in Azure Data Factory (ADF) does not support using Dynamics AX as a sink , this is called out here . This means that you cannot use the Dynamics AX connector to directly load data into Dynamics AX.

However, there are a few alternatives you can consider:

Write custom code: If you are comfortable writing code, you can write a custom program or script to load the data into Dynamics AX. This approach gives you the most flexibility and control, but it requires more development effort.

In general, the best approach will depend on your specific requirements and constraints. If you want to avoid writing code, using a staging table or a third-party connector may be the best option. If you need more control over the data loading process, writing custom code may be the best option.

Thanks

Himanshu